M Aterialization Is a Vailable

The role of materialized views is becoming vital in today’s distributed Data warehouses. Materialization is where parts of the data cube are pre-computed. Some of the real time distributed architectures are maintaining materialization transparencies in the sense the users are not known with the materialization at a node. Usually what all followed by them is a cache maintenance mechanism where the query results are cached. When a query requesting materialization arrives at a distributed node it checks in its cache and if the materialization is available answers the query. What if materialization is not availablethe node communicates the query in the network until a node answering the requested materialization is available. This type of network communication increases the number of query forwarding’s between nodes. The aim of this paper is to reduce the multiple redirects. In this paper we propose a new CB-pattern tree indexing to identify the exact distributed node where the needed materialization is available.